To pass the certification exams, you need to master the following skills:
Write SQL SELECT statements that display data using both single
and group function
Restrict, sort, aggregate, and manipulate data using both single
and group functions.
Create users and roles to control user access and maintain
security.
Understand Oracle Server architecture (database and instance).
Understand the physical and logical storage of the database, and
be able to manage space allocation and growth.
Manage data, including its storage, loading, and reorganization.
Manage redo logs, automatic undo, and rollback segments.
Use globalization features to choose a database character set and
National Language Support (NLS) parameters.
Configure Net8 on the server side and the client side.
Use backup and recovery options.
Archive redo logs files and hot backups.
Perform backup and recovery operations using Recovery Manager (RMAN).
Use data dictionary views and set database parameters.
Configure and use multithreaded server (MTS) and Connection
Manager.
Identify and tune database and SQL performance.
Use the tuning/diagnostics tools STATSPACK, TKPROF, and EXPLAIN
PLAN.
Tune the size of data blocks, the shared pool, the buffer caches,
and rollback segments.
Diagnose contention for latches, locks, and rollback segments.